<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('department_basic_quotes', function (Blueprint $table) {
            $table->id();

            $table->char('quote_name',32)->comment('报价名称');
            $table->integer('department_id')->comment('服务部门id');
            $table->integer('service_cate_id')->comment('服务项目id');
            $table->text('price_content')->comment('日均咨询量价格');
            $table->text('primary_category')->nullable()->comment('初级类目');
            $table->text('middle_category')->nullable()->comment('中级类目');
            $table->text('complicated_platform')->nullable()->comment('复杂平台');
            $table->integer('old_service_cate_id')->nullable()->comment('修改前服务项目id');
            $table->text('old_price_content')->nullable()->comment('修改前报价信息');

            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('department_basic_quotes');
    }
};
